Tabela WaitingListItem

Definicja tabeli WaitingListItem

Name

WaitingListItem

Code

WaitingListItem

Comment

 


Lista kolumn tabeli WaitingListItem

Name

Code

WaitingListItemID

WaitingListItemID

WaitingListID

WaitingListID

PatientID

PatientID

StatusID

StatusID

EventID

EventID

WaitListItemHistoryID

WaitListItemHistoryID

InsertDate

InsertDate

InsertPerson

InsertPerson

WLItemNo

WLItemNo


Kolumna WaitingListItemID tabeli WaitingListItem

Definicja kolumny WaitingListItemID tabeli WaitingListItem

Name

WaitingListItemID

Code

WaitingListItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna WaitingListID tabeli WaitingListItem

Definicja kolumny WaitingListID tabeli WaitingListItem

Name

WaitingListID

Code

WaitingListID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientID tabeli WaitingListItem

Definicja kolumny PatientID tabeli WaitingListItem

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StatusID tabeli WaitingListItem

Definicja kolumny StatusID tabeli WaitingListItem

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventID tabeli WaitingListItem

Definicja kolumny EventID tabeli WaitingListItem

Name

EventID

Code

EventID

Data Type

NUMBER(19)

Mandatory

No

Comment

 


Kolumna WaitListItemHistoryID tabeli WaitingListItem

Definicja kolumny WaitListItemHistoryID tabeli WaitingListItem

Name

WaitListItemHistoryID

Code

WaitListItemHistoryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli WaitingListItem

Definicja kolumny InsertDate tabeli WaitingListItem

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

Data wprowadzenia na liste


Kolumna InsertPerson tabeli WaitingListItem

Definicja kolumny InsertPerson tabeli WaitingListItem

Name

InsertPerson

Code

InsertPerson

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Osoba wpisujaca na liste oczekujacych


Kolumna WLItemNo tabeli WaitingListItem

Definicja kolumny WLItemNo tabeli WaitingListItem

Name

WLItemNo

Code

WLItemNo

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Lista kluczy tabeli WaitingListItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WaitingListItem

Definicja klucza Identifier_1 tabeli WaitingListItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment